package com.gxan.dao;

import com.gxan.pojo.Recruit;
import com.gxan.pojo.Resume;
import com.gxan.pojo.SysDept;
import com.gxan.pojo.SysJob;

import java.sql.SQLException;
import java.util.List;

public interface RecruitDao {
    List<Recruit> findAllPosts(Integer offset, Integer limit) throws SQLException;

    Integer countAll() throws SQLException;

    int delPostById(Integer recruitId) throws SQLException;

    int updatePost(Recruit recruit) throws SQLException;

    int addPost(Recruit recruit) throws SQLException;

    List<Recruit> searchPost(String jobName, String jobType, String time1, String time2, Integer offset, Integer limit) throws SQLException;

    int countSearch(String jobName, String jobType, String time1, String time2) throws SQLException;

    List<Resume> findAllResume(Integer offset, Integer limit) throws SQLException;

    Integer countAllResume() throws SQLException;

    int addResume(Resume resume) throws SQLException;

    int delResumeById(Integer resumeId) throws SQLException;

    List<Resume> findAllInterview(Integer offset, Integer limit) throws SQLException;

    Integer countAllInterview() throws SQLException;

    List<Resume> findAllHire(Integer offset, Integer limit) throws SQLException;

    Integer countAllHire() throws SQLException;

    List<SysJob> getJobName() throws SQLException;

    List<SysDept> getDeptName() throws SQLException;

    int updateResume(Resume resume) throws SQLException;

    List<Resume> searchResume(String name, String jobName, String experience, String status, String regTime, Integer offset, Integer limit) throws SQLException;

    int countSearchResume(String name, String jobName, String experience, String status, String regTime) throws SQLException;

    int addInterview(Integer resumeId) throws SQLException;

    int updateInterview(Resume resume) throws SQLException;

    int addHire(Integer resumeId, Integer interviewId) throws SQLException;

    int updateStatus(String status, Integer resumeId) throws SQLException;

    int updateHire(Resume resume) throws SQLException;
}
